StringFunctions.Translate function

Returns the application dictionary translation for a string expression in the current user locale

Format

SQL Format:

TRANSLATE( expression )

ODBC Format:

{{ FN TRANSLATE( expression ) }}

Remarks

The scalar function TRANSLATE returns the translated application dictionary for a string. The locale setting for the user making the query is used to set the target language.

Example:

The following example would return points with the text 'haut' if this language string was configured:

SELECT TRANSLATE(HighDesc) FROM CPointAlgManual


Disclaimer

ClearSCADA 2017 R3